UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zs4YgipIoKtFDURelMVYJj0rox5X+Zli+P+jLFCrtyM='
WHERE
key_id = '28b6fc3e6a0f1e6da8509855235cf349a2d3bfec7d7bf3631380f8515ab26c33'
AND (
token = 'Zs4YgipIoKtFDURelMVYJj0rox5X+Zli+P+jLFCrtyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)