UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7URKaBSU6oWEglDhE4bsIJYy8tYjgM1Vch6TbbFiqE='
WHERE
key_id = '7988b7a3e423c0507c4a3b7c5050733ac0c42deb10709c67edac8f6be87a3406'
AND (
token = 'i7URKaBSU6oWEglDhE4bsIJYy8tYjgM1Vch6TbbFiqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)