UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'exLaTCXKvZiiJy8wG5NOkjYot7DlKK4OKYNsCygL/l8='
WHERE
key_id = '119ba52f7b1f2eb693806534e83ef956718a7ac31f903ab1b72c062adb3b6cd7'
AND (
token = 'exLaTCXKvZiiJy8wG5NOkjYot7DlKK4OKYNsCygL/l8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)