UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N+GPjxk3202xCSGYCozie677gEi6244kYLDXQn762gI='
WHERE
key_id = 'da54fb10bf44d91784404c262eb8e246959f3f5cc787a1e40a321bf4998901dd'
AND (
token = 'N+GPjxk3202xCSGYCozie677gEi6244kYLDXQn762gI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)