UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dH6ZJUVhcqBjptAvdyApNvFcyE4RYOV0FvWklRijiDE='
WHERE
key_id = '0afb48032783debda2cc1dc4ce2c9130fa4466a2bd57f075ffc22c6e2d3792ea'
AND (
token = 'dH6ZJUVhcqBjptAvdyApNvFcyE4RYOV0FvWklRijiDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)