UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtC/+hW/yuyXWxGLV83cGGAniN2Wk6Ka+OP7o149F/8='
WHERE
key_id = 'e83d9c7420a774bbbab70a051f2e61c986896bec7db9a181570d9b874ecf09c4'
AND (
token = 'XtC/+hW/yuyXWxGLV83cGGAniN2Wk6Ka+OP7o149F/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)