UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0iU+G7ehu6u5qIzrHOdo4Rf/Ws6u5heMdXLtfbLyG14='
WHERE
key_id = '8dcec464f28fb1f916e26b1457eff452cfb4c7c9a5137122015529e6ba013177'
AND (
token = '0iU+G7ehu6u5qIzrHOdo4Rf/Ws6u5heMdXLtfbLyG14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)