UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VIY6qYVebbCeqzjp43W0KDBVkbEvP4A1TFPkgP3MUXI='
WHERE
key_id = '2a947eabb2ad18b863385764c6d87a714f9cc8f0ab1f356456794a4086dd6f0b'
AND (
token = 'VIY6qYVebbCeqzjp43W0KDBVkbEvP4A1TFPkgP3MUXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)