UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/s4KDMquwZA1v2iQpq11px5BLgkuyDoV01UZrwzXwV8='
WHERE
key_id = 'ec88df7e2659b642d84fb5b53ee5fc54f116472e093ef95dceb5f15a39abbfc2'
AND (
token = '/s4KDMquwZA1v2iQpq11px5BLgkuyDoV01UZrwzXwV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)