UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nM6F0jUHvetlOhLVe35W4csZ7BkvE1eKF/V8vaX3IYU='
WHERE
key_id = '8f7b7d555e57f08f8310a94346da4f2a7f4c1d74b7070b433266c01abbd555c2'
AND (
token = 'nM6F0jUHvetlOhLVe35W4csZ7BkvE1eKF/V8vaX3IYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)