UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDhiTdY6QY87CCT18xl4EchLUf67KVrtFLkd5uZsx40='
WHERE
key_id = '28aadb02b5d17bb0480815ce6a1f77e9aca8dfff6f738d85aede2e98043530ea'
AND (
token = 'CDhiTdY6QY87CCT18xl4EchLUf67KVrtFLkd5uZsx40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)