UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lNEDjL81Gzxl/3YmEM91rbIgC/9HayGS6odU7zlGZM='
WHERE
key_id = '1d9c7df1229413286ea6e87f2fbee2076b0451a60f77c7c3484c744217019d0e'
AND (
token = '/lNEDjL81Gzxl/3YmEM91rbIgC/9HayGS6odU7zlGZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)