UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4zayb7A5xtRsIz2RR2Q0e8zm3YltyNLezT22DpY7F20='
WHERE
key_id = '4dc627d783cb36786457c0f425c3d4733ab394110309f06e84ebd5138c16c8c8'
AND (
token = '4zayb7A5xtRsIz2RR2Q0e8zm3YltyNLezT22DpY7F20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)