UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgdWqzBXG2UEn5y30ilqFGVDLvnp/dpZ4Bo0otrmPr0='
WHERE
key_id = '7548f7f7c3fb2573d8a9fc11cf6c05ae6c5e5f24862e773f3c9e7a8653bf3143'
AND (
token = 'BgdWqzBXG2UEn5y30ilqFGVDLvnp/dpZ4Bo0otrmPr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)