UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lA0FDgswJ4eupAeSBLZX2cYNJdUtkiDUwSMv2iyG7U='
WHERE
key_id = '04216d74d36293e0cfd517177775ec7f23e7512c5a81431f40ec6c40941ec4ee'
AND (
token = '4lA0FDgswJ4eupAeSBLZX2cYNJdUtkiDUwSMv2iyG7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)