UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zq+OFppY3RkzomqAA1g346c2RboMOnycqAGy7XGQnCs='
WHERE
key_id = '0122acb6aeb5abdac25bbd00a62367a300f00f8a97f466e14b70eef97c5e204e'
AND (
token = 'Zq+OFppY3RkzomqAA1g346c2RboMOnycqAGy7XGQnCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)