UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUKBXPBHvj8Yy4zhV/shCZuXS3Zzimy875R2H2zyVDw='
WHERE
key_id = '6e370818557bfc697372f3d2f9b22ee59d555cd4d52ed2ce765119ab74403b75'
AND (
token = 'nUKBXPBHvj8Yy4zhV/shCZuXS3Zzimy875R2H2zyVDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)