UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IiNt6fiFTygsx/6CeKzFTIiN1fY4KBJCGO72dreTg30='
WHERE
key_id = '34e2439f83f2f55e86511af364e512bc647d56c0ca950f81c9034da3633ec8eb'
AND (
token = 'IiNt6fiFTygsx/6CeKzFTIiN1fY4KBJCGO72dreTg30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)