UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2RhaqP39YbEfiU3EuHK3AlZuEEXFUw+s83fGINwVFk='
WHERE
key_id = 'c611b69b0a9af796961d957236c4b4bc1aa2ccda93f2ca302c22b867b46c1530'
AND (
token = 'x2RhaqP39YbEfiU3EuHK3AlZuEEXFUw+s83fGINwVFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)