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