UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6D8DWqq+o6+gIVRVhtNFCNLuvN6dpVzMF8N7ARbsJoQ='
WHERE
key_id = 'a1cabf9fa84a1fd4df22fdc127638da9e70362466632e2efdf6b625792bc2cbe'
AND (
token = '6D8DWqq+o6+gIVRVhtNFCNLuvN6dpVzMF8N7ARbsJoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)