UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nzsQyd5NrND1BQ3o5Avna4co5JvBVEGW18WhtFsu9O8='
WHERE
key_id = '969ad11c8fc4f148c93077b7f265c2b436274d14940b19ac4ff50d53a15d54fe'
AND (
token = 'nzsQyd5NrND1BQ3o5Avna4co5JvBVEGW18WhtFsu9O8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)