UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4WCTrEOu+IPgmd8Uj/0hmDL2TtBntgRDRz+j47zFBXA='
WHERE
key_id = '1678ef42f627b32e749f32cd0446d62bc7bb2294995bb4f7accf6eb01a125b75'
AND (
token = '4WCTrEOu+IPgmd8Uj/0hmDL2TtBntgRDRz+j47zFBXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)