UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hr8LYk+UlcFcnTKv9MZ0h2kxVrmrdVOgR1pQwOxGgX4='
WHERE
key_id = 'dfbcd778c30bbacb803ce69205eab4e36483d93e4f7e6056a0270499e658b2b7'
AND (
token = 'hr8LYk+UlcFcnTKv9MZ0h2kxVrmrdVOgR1pQwOxGgX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)