UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YQ6JhHQiCI8LpTPXbTymElWmTKoKRKZQi+4gvJ+8Rak='
WHERE
key_id = '99247e9d41fcfad2360c3ec78668b4d994bda069888e99f93f6676f473f3af58'
AND (
token = 'YQ6JhHQiCI8LpTPXbTymElWmTKoKRKZQi+4gvJ+8Rak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)