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