UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VIjlyAm9yX5Xo16jDJkHTdleFYxm88YWYyzXE0kY0iw='
WHERE
key_id = 'ad1289e9fade0d4e8c56f9c848333eb7a25b866b6b11fb9c77094e054423fb1d'
AND (
token = 'VIjlyAm9yX5Xo16jDJkHTdleFYxm88YWYyzXE0kY0iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)