UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6mVfE+NetyC/XTT1hF4ER7Qykku9bv/KdmZMykV2QA='
WHERE
key_id = '9a93d316647dd469b86b009b7b34d9d7368c4a46e286d6793739cd848976752b'
AND (
token = 'i6mVfE+NetyC/XTT1hF4ER7Qykku9bv/KdmZMykV2QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)