UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/vEAovGMYHgaLcSh1jE1xubyKjXqhD5s559T9/zpTbI='
WHERE
key_id = '9e376f817de6da168000d56b3353b3c43832738e8bdbc11ca2adba754fd6742f'
AND (
token = '/vEAovGMYHgaLcSh1jE1xubyKjXqhD5s559T9/zpTbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)