UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B2A2YDatFhFl9ZRzJMzjzEBgW79f1jsiMpFPewsiu1U='
WHERE
key_id = '8dac4c8b1dba4b696f31b88a878db9c4a6e94bf78b9d4ec39ac539159a123e2e'
AND (
token = 'B2A2YDatFhFl9ZRzJMzjzEBgW79f1jsiMpFPewsiu1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)