UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XTfinTmC47/oh28EXW4XtV3ol2Uw3c+qrZC6o+GIla8='
WHERE
key_id = 'b309c7e8870f9885a5312512ec9f21df906948e4c91ecfb095b6a5b25161d110'
AND (
token = 'XTfinTmC47/oh28EXW4XtV3ol2Uw3c+qrZC6o+GIla8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)