UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TGxrBCk14MLYZTo3QQ3D8e4o0EAF9G3nPEwNI7AZHgM='
WHERE
key_id = 'f2493c8ae0f900b93f27ca499d444b0e3679c10e72663d02c1b51c5c6ba40ad9'
AND (
token = 'TGxrBCk14MLYZTo3QQ3D8e4o0EAF9G3nPEwNI7AZHgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)