UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9FkG0xS1GUowlLXUo3vrabO57LaqDZEgzHjY96G+dTE='
WHERE
key_id = '5171dde89ac228a74611bf8bc414d6b3c72fc85bf9adb090f017ea95cc8721ac'
AND (
token = '9FkG0xS1GUowlLXUo3vrabO57LaqDZEgzHjY96G+dTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)