UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JHJ0hZI6bNNJX2JkKD8YaHAeuI0oFGKZ9GTLcpMz8+s='
WHERE
key_id = 'bb37cdbd087feccb58709c0e516b74c4a111d48d76ae2583fe5f831f8881975a'
AND (
token = 'JHJ0hZI6bNNJX2JkKD8YaHAeuI0oFGKZ9GTLcpMz8+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)